package com.weixin.dao;

import java.sql.SQLException;
import java.util.List;

import com.weixin.vo.Member;
import com.weixin.vo.MemberList;

public interface IUser_tableDAO {
	
	/**
	 * 查询user_table表共有多少条数据
	 * @throws SQLException 
	 */
	int findTotal() throws SQLException;
	
	/**
	 * 根据会员编号查询会员信息
	 * @param user_id
	 * @return
	 * @throws SQLException 
	 */
	Member findById(int user_id) throws SQLException;
	
	/**
	 * 会员充值
	 * @throws SQLException 
	 */
	boolean addMoney(double money, double user_money, int user_id) throws SQLException;

	/**
	 * 修改状态id
	 * @throws SQLException 
	 */
	
	boolean editActi_id(int user_id,int acti_id) throws SQLException;
	
	/**
	 * 根据会员id查询会员信息
	 * 数据库表
	 */
	public List<Member> selectInfoAndSearch(int user_id,int pageNum,int pageSize) throws SQLException;
}
